/*
 Navicat Premium Data Transfer

 Source Server         : localhost_docker_mysql_8
 Source Server Type    : MySQL
 Source Server Version : 80033 (8.0.33)
 Source Host           : localhost:7001
 Source Schema         : spa

 Target Server Type    : MySQL
 Target Server Version : 80033 (8.0.33)
 File Encoding         : 65001

 Date: 24/02/2024 10:46:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for databasechangelog
-- ----------------------------
DROP TABLE IF EXISTS `databasechangelog`;
CREATE TABLE `databasechangelog` (
  `ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `AUTHOR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `FILENAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `DATEEXECUTED` datetime NOT NULL,
  `ORDEREXECUTED` int NOT NULL,
  `EXECTYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `MD5SUM` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DESCRIPTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `COMMENTS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TAG` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LIQUIBASE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CONTEXTS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `LABELS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DEPLOYMENT_ID` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of databasechangelog
-- ----------------------------
BEGIN;
INSERT INTO `databasechangelog` (`ID`, `AUTHOR`, `FILENAME`, `DATEEXECUTED`, `ORDEREXECUTED`, `EXECTYPE`, `MD5SUM`, `DESCRIPTION`, `COMMENTS`, `TAG`, `LIQUIBASE`, `CONTEXTS`, `LABELS`, `DEPLOYMENT_ID`) VALUES ('20200522-02', 'yunshan', 'db/changelog/sqlData.xml', '2022-09-30 14:42:19', 1, 'EXECUTED', '8:baf8f96bd2fda1c67274b3706c45e48a', 'sqlFile', '', NULL, '4.9.1', NULL, NULL, '4548939207');
COMMIT;

-- ----------------------------
-- Table structure for databasechangeloglock
-- ----------------------------
DROP TABLE IF EXISTS `databasechangeloglock`;
CREATE TABLE `databasechangeloglock` (
  `ID` int NOT NULL,
  `LOCKED` bit(1) NOT NULL,
  `LOCKGRANTED` datetime DEFAULT NULL,
  `LOCKEDBY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of databasechangeloglock
-- ----------------------------
BEGIN;
INSERT INTO `databasechangeloglock` (`ID`, `LOCKED`, `LOCKGRANTED`, `LOCKEDBY`) VALUES (1, b'0', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for gen_data_info
-- ----------------------------
DROP TABLE IF EXISTS `gen_data_info`;
CREATE TABLE `gen_data_info` (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一标识',
  `db_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据库名称',
  `drive` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '驱动',
  `catalog` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '目录',
  `db_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据源URL',
  `db_username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账号',
  `db_password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of gen_data_info
-- ----------------------------
BEGIN;
INSERT INTO `gen_data_info` (`id`, `db_name`, `drive`, `catalog`, `db_url`, `db_username`, `db_password`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('4e75d9f6faf9cd1ea42f136ba4276c26', '1', '1', '1', '1', '1', '1', '1', '2024-02-22 23:11:46', '1', '2024-02-22 23:11:46');
COMMIT;

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table` (
  `id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表名',
  `comments` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '实体类名称',
  `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成模块名',
  `subModule_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成子模块名',
  `function_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成功能名',
  `function_name_simple` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成功能名（简写）',
  `function_author` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成功能作者',
  `output_dir` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '输出路径',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `db_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据源名称',
  `db_id` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据源id',
  `template_name` text COLLATE utf8mb4_general_ci COMMENT '模版路径',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of gen_table
-- ----------------------------
BEGIN;
INSERT INTO `gen_table` (`id`, `name`, `comments`, `class_name`, `package_name`, `module_name`, `subModule_name`, `function_name`, `function_name_simple`, `function_author`, `output_dir`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `db_name`, `db_id`, `template_name`) VALUES (1, 'gen_table', 'comments', NULL, 'com.spa.modules', 'sys', NULL, 'zw', NULL, 'zw', 'E://code-generate', NULL, '1', '2022-10-06 00:51:14', '1', '2023-01-10 22:24:36', NULL, NULL, NULL);
INSERT INTO `gen_table` (`id`, `name`, `comments`, `class_name`, `package_name`, `module_name`, `subModule_name`, `function_name`, `function_name_simple`, `function_author`, `output_dir`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `db_name`, `db_id`, `template_name`) VALUES (2, 'spa_menu', '菜单', NULL, 'com.spa.modules', 'spa', NULL, '菜单管理', NULL, 'zw', 'E:\\code-generate', NULL, '1', '2022-10-06 18:34:15', '1', '2023-01-14 14:00:35', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column` (
  `id` int NOT NULL COMMENT '唯一标识',
  `table_id` int DEFAULT NULL COMMENT '表id',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列名',
  `comments` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `jdbc_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'JDBC类型',
  `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否主键（1：主键）',
  `java_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'JAVA字段名',
  `show_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字段生成方案（文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择）',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典类型',
  `sort` int DEFAULT NULL COMMENT '排序（升序）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for spa_menu
-- ----------------------------
DROP TABLE IF EXISTS `spa_menu`;
CREATE TABLE `spa_menu` (
  `id` bigint NOT NULL COMMENT '编号',
  `parent_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '父级编号',
  `path` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `component` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '组件',
  `order_no` int NOT NULL COMMENT '排序',
  `icon` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '图标',
  `title` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '名称',
  `permission` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '权限标识',
  `create_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '更新者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sys_menu_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='菜单表';

-- ----------------------------
-- Records of spa_menu
-- ----------------------------
BEGIN;
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, '0', '/dashboard', 'LAYOUT', 12, 'ant-design:aliwangwang-outlined', 'Dashboard', 'Dashboard:list', '1', '2023-01-14 15:37:57', '1', '2023-01-17 22:23:13');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2, '1', '/analysis', '/dashboard/analysis/index', 1, NULL, '分析页', 'analysis:list', '1', '2023-01-14 15:38:23', '1', '2023-01-14 15:38:25');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (3, '1', '/workbench', '/dashboard/workbench/index', 1, NULL, '工作台', 'workbench:list', '1', '2023-01-14 15:38:49', '1', '2023-01-14 15:38:54');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (4, '0', '/system', 'LAYOUT', 1, 'ant-design:account-book-outlined', '系统管理', 'system:list', '1', '2023-01-14 15:43:55', '1', '2023-01-17 22:26:00');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (5, '4', '/role', '/system/spaUserRole/index', 1, NULL, '角色管理', 'role:list', '1', '2023-01-14 15:45:23', '1', '2023-01-14 15:45:26');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (6, '4', '/spaUser', '/system/spaUser/index', 1, NULL, '用户管理', 'spaUser:list', '1', '2023-01-14 15:45:42', '1', '2023-01-14 15:45:48');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (7, '4', '/sysLog', '/system/sysLog/index', 1, NULL, '系统日志', 'sysLog:list', '1', '2023-01-14 15:46:08', '1', '2023-01-14 15:46:11');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (8, '4', '/gen', '/system/gen/index', 1, NULL, '代码生成', 'gen:table:listByPage', '1', '2023-01-14 15:46:31', '1', '2023-01-14 15:46:35');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (9, '4', '/spaMenu', '/spa/spaMenu/index', 1, NULL, '菜单管理', 'spa:spaMenu:menuTrue', '1', '2023-01-14 15:46:54', '1', '2023-01-14 15:46:57');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1618162201790631938, '0', '/monitor', 'LAYOUT', 1, NULL, '系统监控', NULL, '1', '2023-01-25 16:21:48', '1', '2023-01-25 16:21:48');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1618173014798516225, '1618162201790631938', '/redis', '/monitor/redis/index', 1, NULL, 'redis监控', NULL, '1', '2023-01-25 17:04:46', '1', '2023-01-25 17:11:56');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1618188145775419394, '1618162201790631938', '/server', '/monitor/server/index', 1, NULL, '性能监控', NULL, '1', '2023-01-25 18:04:53', '1', '2023-01-25 18:04:53');
INSERT INTO `spa_menu` (`id`, `parent_id`, `path`, `component`, `order_no`, `icon`, `title`, `permission`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1618209539020111873, '1618162201790631938', '/quartz', '/monitor/quartz/index', 1, NULL, '定时任务', NULL, '1', '2023-01-25 19:29:54', '1', '2023-01-25 19:29:54');
COMMIT;

-- ----------------------------
-- Table structure for spa_user
-- ----------------------------
DROP TABLE IF EXISTS `spa_user`;
CREATE TABLE `spa_user` (
  `id` bigint NOT NULL COMMENT '唯一标识',
  `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
  `usr_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `usr_pwd` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `usr_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '手机',
  `role_id` bigint DEFAULT NULL COMMENT '角色',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of spa_user
-- ----------------------------
BEGIN;
INSERT INTO `spa_user` (`id`, `real_name`, `usr_name`, `usr_pwd`, `usr_email`, `mobile`, `role_id`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, '测试', 'test', '64c9a18436c023ab', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spa_user` (`id`, `real_name`, `usr_name`, `usr_pwd`, `usr_email`, `mobile`, `role_id`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1617780720282947586, 'ttt', 'ttt', '6b4057736d662770', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spa_user` (`id`, `real_name`, `usr_name`, `usr_pwd`, `usr_email`, `mobile`, `role_id`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1760674360186249217, 'admin', 'admin', 'c44b01947c9e6e3f', '512878722@qq.com', '18904269056', 1, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for spa_user_role
-- ----------------------------
DROP TABLE IF EXISTS `spa_user_role`;
CREATE TABLE `spa_user_role` (
  `id` bigint NOT NULL,
  `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '描述',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态',
  `menu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单json',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of spa_user_role
-- ----------------------------
BEGIN;
INSERT INTO `spa_user_role` (`id`, `role_name`, `description`, `status`, `menu`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'admin', 'admin', NULL, '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"1618162201790631938\",\"1618173014798516225\",\"1618188145775419394\",\"1618209539020111873\"]', NULL, NULL, NULL, NULL);
INSERT INTO `spa_user_role` (`id`, `role_name`, `description`, `status`, `menu`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1617768231147196418, 'test', 'test', NULL, '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"1618162201790631938\",\"1618173014798516225\",\"1618188145775419394\",\"1618209539020111873\"]', NULL, NULL, NULL, NULL);
INSERT INTO `spa_user_role` (`id`, `role_name`, `description`, `status`, `menu`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1617779464541884417, 'tt', 'tt', NULL, '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"1618162201790631938\",\"1618173014798516225\",\"1618188145775419394\",\"1618209539020111873\"]', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `log_type` int DEFAULT NULL COMMENT '日志类型（1登录日志，2操作日志）',
  `log_content` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '日志内容',
  `operate_type` int DEFAULT NULL COMMENT '操作类型',
  `userid` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '操作用户账号',
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '操作用户名称',
  `ip` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'IP',
  `method` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '请求java方法',
  `request_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '请求路径',
  `request_param` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '请求参数',
  `request_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '请求类型',
  `cost_time` bigint DEFAULT NULL COMMENT '耗时',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_table_userid` (`userid`) USING BTREE,
  KEY `index_logt_ype` (`log_type`) USING BTREE,
  KEY `index_operate_type` (`operate_type`) USING BTREE,
  KEY `index_log_type` (`log_type`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2597 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='系统日志表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (69, 2, '获取用户信息', 1, NULL, NULL, '192.168.56.1', 'com.spa.modules.gen.controller.TestController.userInfo()', NULL, '  genTable: GenTable(name=null, comments=null, dbName=mssql, className=null, nameLike=null)', NULL, 21, NULL, '2022-10-01 10:06:02', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (70, 2, '获取用户信息', 1, NULL, NULL, '192.168.56.1', 'com.spa.modules.gen.controller.TestController.userInfo()', NULL, '  genTable: GenTable(name=null, comments=null, dbName=mssql, className=null, nameLike=null)', NULL, 5, NULL, '2022-10-01 10:06:15', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (71, 2, '获取用户信息', 1, NULL, NULL, '192.168.56.1', 'com.spa.modules.gen.controller.TestController.userInfo()', NULL, '  genTable: GenTable(name=null, comments=null, dbName=mysql, className=null, nameLike=null)', NULL, 28, NULL, '2022-10-01 10:24:41', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2514, 2, '用户登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"123456\",\"username\":\"test\"}]', NULL, 236, NULL, '2024-02-22 21:24:39', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2515, 2, '用户登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"123456\",\"username\":\"vben\"}]', NULL, 40, NULL, '2024-02-22 21:24:49', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2516, 2, '用户登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"123456\",\"username\":\"test\"}]', NULL, 35, NULL, '2024-02-22 21:25:05', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2517, 2, '用户登录', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"test\",\"realName\":\"测试\",\"token\":\"ebf13f5c-777f-4134-8a1c-281f873214a9\",\"username\":\"test\"}]', NULL, 166, NULL, '2024-02-22 21:26:01', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2518, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 40, NULL, '2024-02-22 21:26:01', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2519, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 65, NULL, '2024-02-22 21:26:01', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2520, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 4, NULL, '2024-02-22 21:26:35', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2521, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 6, NULL, '2024-02-22 21:26:35', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2522, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@5a9fb96d  page: 1  pageSize: 10', NULL, 62, NULL, '2024-02-22 21:26:38', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2523, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.getAllRoleList()', NULL, '', NULL, 59, NULL, '2024-02-22 21:26:52', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2524, 2, '菜单-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuTrue()', NULL, '', NULL, 110, NULL, '2024-02-22 21:27:29', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2525, 2, '菜单-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuTrueAll()', NULL, '', NULL, 149, NULL, '2024-02-22 21:27:36', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2526, 2, '菜单-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuTrue()', NULL, '', NULL, 147, NULL, '2024-02-22 21:28:20', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2527, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@7143ec6c  page: 1  pageSize: 10', NULL, 46, NULL, '2024-02-22 21:29:19', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2528, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 7, NULL, '2024-02-22 21:30:37', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2529, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 8, NULL, '2024-02-22 21:30:37', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2530, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@c9562e41  page: 1  pageSize: 10', NULL, 42, NULL, '2024-02-22 21:30:42', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2531, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 5, NULL, '2024-02-22 21:37:56', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2532, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 4, NULL, '2024-02-22 21:37:56', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2533, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@6c9c3210  page: 1  pageSize: 10', NULL, 40, NULL, '2024-02-22 21:37:57', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2534, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 10, NULL, '2024-02-22 21:41:19', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2535, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 4, NULL, '2024-02-22 21:41:19', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2536, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@4535f56a  page: 1  pageSize: 10', NULL, 34, NULL, '2024-02-22 21:41:20', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2537, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 4, NULL, '2024-02-22 21:41:27', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2538, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 5, NULL, '2024-02-22 21:41:27', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2539, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@6915b756  page: 1  pageSize: 10', NULL, 61, NULL, '2024-02-22 21:41:27', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2540, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@fce50671  page: 1  pageSize: 10', NULL, 50, NULL, '2024-02-22 21:41:32', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2541, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@c080b916  page: 1  pageSize: 10', NULL, 57, NULL, '2024-02-22 21:41:35', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2542, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 6, NULL, '2024-02-22 21:41:42', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2543, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 3, NULL, '2024-02-22 21:41:42', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2544, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@377ab7f  page: 1  pageSize: 10', NULL, 82, NULL, '2024-02-22 21:41:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2545, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 9, NULL, '2024-02-22 21:42:38', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2546, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 4, NULL, '2024-02-22 21:42:38', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2547, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@13a0e4a  page: 1  pageSize: 10', NULL, 49, NULL, '2024-02-22 21:42:39', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2548, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 5, NULL, '2024-02-22 21:44:50', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2549, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 3, NULL, '2024-02-22 21:44:51', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2550, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@db838dd5  page: 1  pageSize: 10', NULL, 61, NULL, '2024-02-22 21:59:27', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2551, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 8, NULL, '2024-02-22 22:00:18', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2552, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 7, NULL, '2024-02-22 22:00:18', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2553, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@8a467bc4  page: 1  pageSize: 10', NULL, 53, NULL, '2024-02-22 22:00:18', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2554, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 3, NULL, '2024-02-22 22:00:40', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2555, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 4, NULL, '2024-02-22 22:00:40', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2556, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@dd9aa45f  page: 1  pageSize: 10', NULL, 67, NULL, '2024-02-22 22:00:40', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2557, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@12dbe4ca  page: 1  pageSize: 10', NULL, 464, NULL, '2024-02-22 22:00:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2558, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@eee1056d  page: 1  pageSize: 10', NULL, 63, NULL, '2024-02-22 22:00:44', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2559, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@29ced9ac  page: 1  pageSize: 10', NULL, 342, NULL, '2024-02-22 22:00:45', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2560, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 5, NULL, '2024-02-22 22:05:29', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2561, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 5, NULL, '2024-02-22 22:05:29', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2562, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@f9442759  page: 1  pageSize: 10', NULL, 332, NULL, '2024-02-22 22:05:30', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2563, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@86beaeea  page: 1  pageSize: 10', NULL, 56, NULL, '2024-02-22 22:05:32', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2564, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@e247f719  page: 1  pageSize: 10', NULL, 55, NULL, '2024-02-22 22:05:33', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2565, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@12255de1  page: 1  pageSize: 10', NULL, 374, NULL, '2024-02-22 22:05:34', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2566, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 4, NULL, '2024-02-22 22:18:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2567, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 6, NULL, '2024-02-22 22:18:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2568, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@afcf003c  page: 1  pageSize: 10', NULL, 402, NULL, '2024-02-22 22:18:47', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2569, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@ef2c0685  page: 1  pageSize: 10', NULL, 80, NULL, '2024-02-22 22:33:33', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2570, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@51c8ec7  page: 1  pageSize: 10', NULL, 68, NULL, '2024-02-22 22:33:34', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2571, 2, '角色-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserRoleController.getAllRoleList()', NULL, '', NULL, 58, NULL, '2024-02-22 22:33:39', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2572, 2, '用户-添加', 2, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.add()', NULL, '[{\"id\":1760674360186249217,\"mobile\":\"18904269056\",\"realName\":\"admin\",\"roleId\":1,\"usrEmail\":\"512878722@qq.com\",\"usrName\":\"admin\",\"usrPwd\":\"c44b01947c9e6e3f\"}]', NULL, 46, NULL, '2024-02-22 22:34:14', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2573, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@fbc2fa16  page: 1  pageSize: 10', NULL, 44, NULL, '2024-02-22 22:34:14', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2574, 2, '管理员注销登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.logout()', NULL, '', NULL, 64, NULL, '2024-02-22 22:34:25', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2575, 2, '用户登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"test\",\"username\":\"admin\"}]', NULL, 54, NULL, '2024-02-22 22:34:59', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2576, 2, '用户登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"admin\",\"username\":\"admin\"}]', NULL, 52, NULL, '2024-02-22 22:35:16', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2577, 2, '用户登录', 1, NULL, NULL, '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"test\",\"username\":\"admin\"}]', NULL, 56, NULL, '2024-02-22 22:35:32', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2578, 2, '用户登录', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.login()', NULL, '[{\"password\":\"test\",\"realName\":\"测试\",\"token\":\"9cc9f992-2660-493b-9f14-bf61b6cd931a\",\"username\":\"test\"}]', NULL, 91, NULL, '2024-02-22 22:35:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2579, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 4, NULL, '2024-02-22 22:35:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2580, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 5, NULL, '2024-02-22 22:35:43', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2581, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@6724cd16  page: 1  pageSize: 10', NULL, 478, NULL, '2024-02-22 22:36:26', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2582, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SpaUserController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@9d27c35b  page: 1  pageSize: 10', NULL, 64, NULL, '2024-02-22 22:36:28', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2583, 2, '菜单-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuTrue()', NULL, '', NULL, 101, NULL, '2024-02-22 22:36:32', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2584, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 9, NULL, '2024-02-22 22:39:02', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2585, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 5, NULL, '2024-02-22 22:39:02', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2586, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 5, NULL, '2024-02-22 22:42:15', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2587, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 5, NULL, '2024-02-22 22:42:15', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2588, 2, '获取用户信息', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.IndexController.userInfo()', NULL, '', NULL, 6, NULL, '2024-02-22 22:47:49', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2589, 2, '根据登录用户角色获取菜单', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.spa.controller.SpaMenuController.getMenuListByLoginId()', NULL, '', NULL, 4, NULL, '2024-02-22 22:47:50', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2590, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.gen.controller.GenController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@5983b509  page: 1  pageSize: 10', NULL, 103, NULL, '2024-02-22 22:47:50', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2591, 2, '系统日志-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.system.controller.SysLogController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@2450e8c2  page: 1  pageSize: 10', NULL, 398, NULL, '2024-02-22 22:49:11', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2592, 2, '用户-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.gen.controller.GenController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@23046210  page: 1  pageSize: 10', NULL, 79, NULL, '2024-02-22 22:49:17', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2593, 2, '测试数据源链接是否有效', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.gen.controller.GenDataController.testGenDb()', NULL, '[{\"catalog\":\"spa\",\"dbName\":\"localhostDB\",\"dbPassword\":\"xhzq4r\",\"dbUrl\":\"jdbc:mysql://127.0.0.1:7001/spa?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\",\"dbUsername\":\"root\",\"drive\":\"com.mysql.cj.jdbc.Driver\"}]', NULL, 72, NULL, '2024-02-22 22:51:57', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2594, 2, '测试数据源链接是否有效', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.gen.controller.GenDataController.testGenDb()', NULL, '[{\"catalog\":\"spa\",\"dbName\":\"localhostDB\",\"dbPassword\":\"xhzq4r\",\"dbUrl\":\"jdbc:mysql://127.0.0.1:7001/spa?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\",\"dbUsername\":\"root\",\"drive\":\"com.mysql.cj.jdbc.Driver\"}]', NULL, 49, NULL, '2024-02-22 22:52:16', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2595, 2, '数据源-添加', 2, NULL, '1', '127.0.0.1', 'com.spa.modules.gen.controller.GenDataController.add()', NULL, '[{\"catalog\":\"1\",\"createBy\":\"1\",\"createTime\":1708614705865,\"dbName\":\"1\",\"dbPassword\":\"1\",\"dbUrl\":\"1\",\"dbUsername\":\"1\",\"drive\":\"1\",\"id\":\"4e75d9f6faf9cd1ea42f136ba4276c26\",\"updateBy\":\"1\",\"updateTime\":1708614705867}]', NULL, 54, NULL, '2024-02-22 23:11:46', NULL, NULL);
INSERT INTO `sys_log` (`id`, `log_type`, `log_content`, `operate_type`, `userid`, `username`, `ip`, `method`, `request_url`, `request_param`, `request_type`, `cost_time`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2596, 2, '数据源-列表', 1, NULL, '1', '127.0.0.1', 'com.spa.modules.gen.controller.GenDataController.queryPageList()', NULL, '  req: com.spa.common.filter.XssHttpServletRequestWrapper@b3a1c760  page: 1  pageSize: 10', NULL, 46, NULL, '2024-02-22 23:11:46', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
